USE INDEX SET FILTER SET RELATION SET FIELDS SET ORDER SET INDEX SET SKIP SELECT SET KEY REPLACE APPEND BLANK DELETE RECALL CALCULATE SORT
TOPIC
DETAILS
About Migration Tools 8
Help And Assistance 14
Overview 95
Product Support 129
Using Help 109 Convert dBASE Files 75 Label Converter 60 Report Converter 37 Screen Converter 19
About Migration Tools
The FoxPro Migration Tools have been designed and provided to help you identify and convert dBASE III and dBASE IV screens, reports and labels that are not completely compatible with FoxPro.
Copyright (c) 1994 by Microsoft Corporation
ALL RIGHTS RESERVED
Help And Assistance
The Migration Guide documents this software and explains the migration process.
Assistance in using FoxPro Migration Tools is always availble by pressing the F1 function key.ols is always availb
Screen Converter
The Screen Converter is part of the Convert dBASE Files... menu option on the FoxPro Run Menu. A dialog is brought forward listing dBASE IV screens, reports and labels. The converter takes an existing SCR file file and creates a FoxPro SCX screen file. The converted .SCX file can then be modified in the FoxPro Screen Builder.
Limitations:
Individual colors are not preserved for fields.
dBASE IV screens with multiple pages are not preserved in the same manner. The entire set of screens is brought forward in a FoxPro SCX file. However, the dBASE screen code generator creates code which places READ statements between each page. The FoxPro GENSCRN code generator will only create one READ statement. You can create multiple pages by using the Save As... command to create separate SCX files for each page in the dBASE screen.
See Also: Label Converter, Report Converter, Convert dBASE Files
MS Sans Serif
Report Converter
The Report Converter is part of the Convert dBASE Files... menu option on the FoxPro Run menu. A dialog is brought forward listing dBASE IV screens, reports and labels. The converter takes an existing FRM file and creates a FoxPro FRX report file. It should be noted that you can choose not to use the report converter, but instead rely on the code generated report file since FoxPro supports dBASE FRG files.
Limitations:
dBASE supports multiple line text objects with word wrap. In addition, a text object can contain hanging paragraphs and tabs. FoxPro does not support word wrap in the DOS product. The Windows report writer does support word wrap but only for text objects under 255 characters. The report converter creates a series of one-line text objects.
dBASE IV reports allow for Vertical Stretching in any band. FoxPro's report writer only allows this in the Page Header and Detail bands.
dBASE IV band spacing and pitch are not supported.
dBASE IV will print open, but empty bands. FoxPro will ignore them. You can create a blank line in a FoxPro report by inserting a space/hidden character in the dimmed line.
See Also: Screen Converter, Label Converter, Convert dBASE Files
See Also
Label Converter
The Label Converter is part of the Convert dBase Files... menu option. A dialog is brought forward listing a number of files including dBASE IV labels. The converter takes an existing LBL file file and creates a FoxPro LBX label file. The converted .LBX file can then be modified in the FoxPro Label Builder.
Limitations:
Font styles (i.e., bold, underline, italics) are not preserved. In dBASE IV, each specific field/expression can have its own style whereas FoxPro's label LBX file contains only a single style per line.
In dBASE IV 1.1 and 1.5 labels, a top and bottom margin can be specified for each page. FoxPro has no equivalent settings.
See Also: Screen Converter, Report Converter, Convert dBASE Files
Catalog Manager, Tables in Cat
Convert dBASE Files
The Convert dBASE Files menu option on the Run Menu brings up a dialog which allows users to convert existing dBASE IV screen, label, report and .FMT files to equivalent FoxPro files.
Select Files box:
All of the files listed above in the selected directory are listed in this box. You can select multiple files to be copied at once. Simply hit <Enter> or doubleclick on an item to toggle it as selected.
Directory button:
Changes the source/target directory where the files are found and processed.
Select All button:
Selects all the files in the list box.
Clear All button:
Clears all the selected files in the list box.
Process button:
The selected files are converted to FoxPro ones. Actually, the original files are kept intact and new FoxPro ones are created. If a FoxPro file already exists, you are prompted to overwrite it.
Close button:
This button closes the dialog.
Help button:
Brings up Migration Tools on-line help.
See Also: Screen Converter, Report Converter, Label Converter
Overview
The FoxPro Migration Tools are a set of tools designed to help you migrate your existing dBASE IV to the powerful FoxPro for MS-DOS and Windows environments.
The File Converter in the Migration application is very simple to use. You are presented with a dialog of available dBASE IV screen, report and label files, as well as .FMT files. The Converter converts .SCR to .SCX screens, .FRM to .FRX reports, and .LBL to .LBX labels. It is important to know that your original files are still intact. New FoxPro ones are simply created which can be opened using FoxPro's Power Tools.
See Also: Screen Converter, Report Converter, Label Converter
ying many of the comm
Using Help
The Help window consists of two panels -- one lists help topics and the other displays details about each topic.
To select a topic in the Help window:
Scroll through the topics to find the one you want, or
Type a letter or series of letters to select the first topic beginning with those letter(s).
To see details about a topic:
Select the topic and choose the Help push button, or
Select the topic and press Enter, or
Double-click on the topic with the mouse or the Spacebar.
To return to help topics list, choose the Topics push button.
To see information about the next topic, choose the Next push button.
To see information about the previous topic, choose the Previous push button.
You can also get help on a topic by typing HELP in the Command window followed by the desired topic, then pressing Enter.
Context Sensitive Help:
FoxPro provides context-sensitive help. To receive help on a system window or dialog, press F1 or Alt+click when the window or dialog is frontmost. Help information appears. To receive help on a menu option, select the menu option and press F1 or Alt+click.
Product Support
If you have a question about Microsoft FoxPro, first look in the printed product documentation or consult online Help. You can also find late-breaking updates and technical information in the Readme file that came with your FoxPro disks. To diagnose a specific problem, consult the Troubleshooting Charts and Tips Help topic. If you cannot find the answer, contact the Microsoft Support Network.
Outside the United States and Canada, contact Microsoft Product Support Services at the Microsoft subsidiary office that serves your area. For information about Microsoft subsidiary offices, see Product Support Worldwide.
The Microsoft Support Network
The Microsoft Support Network offers you a wide range of choices and access to high-quality, responsive technical support. Microsoft recognizes that support needs vary from user to user; the Microsoft Support Network allows you to choose the type of support that best meets your needs, with options ranging from electronic bulletin boards to annual support programs. For information about support services in the United States and Canada, see Product Support Within the United States and Canada.
Services vary outside the United States and Canada. In other locations, contact a local Microsoft subsidiary for information. The Microsoft Support Network is subject to Microsoft's then-current prices, terms, and conditions, and is subject to change without notice.
Product Support Within the
United States and Canada
In the United States and Canada, the following support services are available through the Microsoft Support Network:
Electronic Services
These services are available 24 hours a day, 7 days a week, including holidays.
Microsoft FastTips
(800) 936-4300 on a touch-tone telephone. Receive automated answers to common questions, and access a library of technical notes, all delivered by recording or fax. You can use the following keys on your touch-tone telephone after you reach FastTips:
To Press
Advance to the *
next message
Repeat the 7
current message
Return to the #
beginning of FastTips
CompuServe
Interact with other users and Microsoft support engineers, or access the Microsoft Knowledge Base to get product information. At any ! prompt, type go microsoft to access Microsoft forums, or type go mskb to access the Microsoft Knowledge Base, or type go foxforum to access FoxPro-specific information. For an introductory CompuServe membership kit, call (800) 848-8199, operator 519.
Microsoft Download Service
Access, via modem, the Driver Library and the most current technical notes (1200, 2400, 9600, or 14400 baud; no parity; 8 data bits; 1 stop bit). In the United States, call (206) 936-6735. In Canada, call (905) 507-3022.
Internet
Access the Driver Library and the Microsoft Knowledge Base. The Microsoft Internet FTP archive host, ftp.microsoft.com, supports anonymous login. When logging in as anonymous, you should type your complete electronic mail name as your password.
Priority Support
The Microsoft Support Network offers priority telephone access to Microsoft support engineers 24 hours a day, 7 days a week, except holidays.
In the United States, call (900) 555-2300; $2 (U.S.) per minute, $95 (U.S.) maximum. Charges appear on your telephone bill.
In the United States, call (800) 936-5800; $95 (U.S.) per incident, billed to your VISA card, MasterCard, or American Express card.
In Canada, call (800) 668-7975 for more information.
Standard Support
In the United States, no-charge support from Microsoft support engineers is available via a toll call between 6:00 A.M. and 6:00 P.M. Pacific time, Monday through Friday, excluding holidays.
This support is available for 90 days after you make your first call.
For technical support for FoxPro for MS-DOS and Windows, call (206) 635-7191.
For technical support for FoxPro for Macintosh, call (206) 635-7192.
In Canada, support engineers are available via a toll call between 8:00 A.M. and 8:00 P.M. Eastern time, Monday through Friday, excluding holidays. Call (905) 568-3503.
When you call, you should be at your computer and have the appropriate product documentation at hand. Be prepared to give the following information:
The version number of the Microsoft product that you are using
The type of hardware that you are using
The exact wording of any messages that appeared on your screen
A description of what happened and what you were doing when the problem occurred
A description of how you tried to solve the problem
Text Telephone
Microsoft text telephone (TT/TDD) services are available for the deaf or hard-of-hearing. In the United States, using a TT/TDD modem, dial (206) 635-4948 between 6:00 A.M. and 6:00 P.M. Pacific time, Monday through Friday, excluding holidays. In Canada, using a TT/TDD modem, dial (905) 568-9641 between 8:00 A.M. and 8:00 P.M. Eastern time, Monday through Friday, excluding holidays.
Other Support Options
The Microsoft Support Network offers annual support plans. For information, in the United States, contact the Microsoft Support Network Sales and Information group at (800) 936-3500 between 6:00 A.M. and 6:00 P.M. Pacific time, Monday through Friday, excluding holidays. In Canada, call (800) 668-7975 between 8:00 A.M. and 8:00 P.M. Eastern time, Monday through Friday, excluding holidays.
Product Training and Consultation
Microsoft Solution Providers are independent organizations that provide consulting, integration, customization, development, technical support and training, and other services for Microsoft products. These companies are called Solution Providers because they apply technology and provide services to help solve real-world problems.In the United States, for more information about the Microsoft Solution Providers program or the Microsoft Solution Provider nearest to you, please call (800) 426-9400 between 6:30 A.M. and 5:30 P.M. Pacific time, Monday through Friday, excluding holidays. In Canada, call (800) 668-7975 between 8:00 A.M. and 8:00 P.M. Eastern time, Monday through Friday, excluding holidays.
Product Support Worldwide
If you are outside the United States or Canada and have a question about a Microsoft product, first:
Consult the documentation and other printed information included with your product.
Check online Help.
Check the Readme files that come with your product disks. These files provide general information that became available after the books in the product package were published.
Consult electronic options such as CompuServe forums or bulletin boards, if available.
If you cannot find a solution, you can receive information on how to obtain product support by contacting the Microsoft subsidiary office that serves your country.
The Microsoft Support Network
The Microsoft Support Network, where available, offers you a wide range of choices and access to high quality, responsive technical support. Microsoft recognizes that support needs vary from user to user; the Microsoft Support Network allows you to choose the type of support that best meets your needs, with options ranging from electronic bulletin boards to annual support programs.
The Microsoft Support Network is subject to Microsoft's then-current prices, terms, and conditions in place in each country at the time the services are used and is subject to change without notice.
Microsoft Subsidiary Information
Calling a Microsoft Subsidiary Office
When you call, you should be at your computer and have the appropriate product documentation at hand. Be prepared to give the following information:
The version number of Microsoft product that you are using.
The type of hardware that you are using, including network hardware, if applicable.
The operating system that you are using.
The exact wording of any messages that appeared on your screen.
A description of what happened and what you were doing when the problem occurred.
A description of how you tried to solve the problem.
If there is no Microsoft office in your country, please contact the establishment from which you purchased your Microsoft product.
Support in Argentina, Bolivia, Paraguay, and Uruguay
(.txt)